Dataset statistics
| Number of variables | 33 |
|---|---|
| Number of observations | 11939 |
| Missing cells | 12924 |
| Missing cells (%) | 3.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 10.6 MiB |
| Average record size in memory | 926.7 B |
Variable types
| Numeric | 15 |
|---|---|
| Categorical | 18 |
country has a high cardinality: 109 distinct values | High cardinality |
reservation_status_date has a high cardinality: 852 distinct values | High cardinality |
df_index is highly correlated with agent | High correlation |
arrival_date_year is highly correlated with arrival_date_week_number | High correlation |
arrival_date_week_number is highly correlated with arrival_date_year | High correlation |
agent is highly correlated with df_index | High correlation |
df_index is highly correlated with agent | High correlation |
arrival_date_year is highly correlated with arrival_date_week_number | High correlation |
arrival_date_week_number is highly correlated with arrival_date_year | High correlation |
is_repeated_guest is highly correlated with previous_bookings_not_canceled | High correlation |
previous_bookings_not_canceled is highly correlated with is_repeated_guest | High correlation |
agent is highly correlated with df_index | High correlation |
is_repeated_guest is highly correlated with previous_bookings_not_canceled | High correlation |
previous_bookings_not_canceled is highly correlated with is_repeated_guest | High correlation |
arrival_date_week_number is highly correlated with arrival_date_month and 3 other fields | High correlation |
hotel is highly correlated with agent and 3 other fields | High correlation |
is_canceled is highly correlated with df_index and 1 other fields | High correlation |
arrival_date_month is highly correlated with arrival_date_week_number and 1 other fields | High correlation |
agent is highly correlated with hotel and 2 other fields | High correlation |
stays_in_weekend_nights is highly correlated with stays_in_week_nights | High correlation |
df_index is highly correlated with arrival_date_week_number and 6 other fields | High correlation |
lead_time is highly correlated with company | High correlation |
assigned_room_type is highly correlated with hotel and 2 other fields | High correlation |
deposit_type is highly correlated with reservation_status | High correlation |
reservation_status is highly correlated with is_canceled and 2 other fields | High correlation |
stays_in_week_nights is highly correlated with stays_in_weekend_nights and 1 other fields | High correlation |
company is highly correlated with arrival_date_week_number and 6 other fields | High correlation |
arrival_date_year is highly correlated with arrival_date_week_number and 2 other fields | High correlation |
previous_cancellations is highly correlated with previous_bookings_not_canceled | High correlation |
market_segment is highly correlated with company and 1 other fields | High correlation |
reserved_room_type is highly correlated with assigned_room_type and 1 other fields | High correlation |
previous_bookings_not_canceled is highly correlated with previous_cancellations | High correlation |
distribution_channel is highly correlated with market_segment | High correlation |
children is highly correlated with assigned_room_type and 1 other fields | High correlation |
market_segment is highly correlated with distribution_channel | High correlation |
assigned_room_type is highly correlated with reserved_room_type | High correlation |
reservation_status is highly correlated with is_canceled | High correlation |
reserved_room_type is highly correlated with assigned_room_type | High correlation |
is_canceled is highly correlated with reservation_status | High correlation |
distribution_channel is highly correlated with market_segment | High correlation |
agent has 1635 (13.7%) missing values | Missing |
company has 11241 (94.2%) missing values | Missing |
adults is highly skewed (γ1 = 20.76322339) | Skewed |
previous_cancellations is highly skewed (γ1 = 23.75659833) | Skewed |
previous_bookings_not_canceled is highly skewed (γ1 = 21.99555117) | Skewed |
df_index has unique values | Unique |
lead_time has 635 (5.3%) zeros | Zeros |
stays_in_weekend_nights has 5276 (44.2%) zeros | Zeros |
stays_in_week_nights has 771 (6.5%) zeros | Zeros |
previous_cancellations has 11325 (94.9%) zeros | Zeros |
previous_bookings_not_canceled has 11560 (96.8%) zeros | Zeros |
booking_changes has 10139 (84.9%) zeros | Zeros |
days_in_waiting_list has 11561 (96.8%) zeros | Zeros |
adr has 204 (1.7%) zeros | Zeros |
total_of_special_requests has 7020 (58.8%) zeros | Zeros |
Reproduction
| Analysis started | 2022-01-18 20:55:08.782011 |
|---|---|
| Analysis finished | 2022-01-18 20:55:54.372008 |
| Duration | 45.59 seconds |
| Software version | pandas-profiling v3.0.0 |
| Download configuration | config.json |
| Distinct | 11939 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59706.35053 |
| Minimum | 5 |
|---|---|
| Maximum | 119388 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 5590.4 |
| Q1 | 29931.5 |
| median | 59416 |
| Q3 | 89234 |
| 95-th percentile | 113493.1 |
| Maximum | 119388 |
| Range | 119383 |
| Interquartile range (IQR) | 59302.5 |
Descriptive statistics
| Standard deviation | 34480.59589 |
|---|---|
| Coefficient of variation (CV) | 0.5775029888 |
| Kurtosis | -1.191425583 |
| Mean | 59706.35053 |
| Median Absolute Deviation (MAD) | 29642 |
| Skewness | 0.002508635686 |
| Sum | 712834119 |
| Variance | 1188911493 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22525 | 1 | < 0.1% |
| 118344 | 1 | < 0.1% |
| 87400 | 1 | < 0.1% |
| 60775 | 1 | < 0.1% |
| 9574 | 1 | < 0.1% |
| 68963 | 1 | < 0.1% |
| 38166 | 1 | < 0.1% |
| 100338 | 1 | < 0.1% |
| 71008 | 1 | < 0.1% |
| 102670 | 1 | < 0.1% |
| Other values (11929) | 11929 |
| Value | Count | Frequency (%) |
| 5 | 1 | |
| 9 | 1 | |
| 24 | 1 | |
| 62 | 1 | |
| 71 | 1 | |
| 74 | 1 | |
| 78 | 1 | |
| 80 | 1 | |
| 84 | 1 | |
| 85 | 1 |
| Value | Count | Frequency (%) |
| 119388 | 1 | |
| 119362 | 1 | |
| 119361 | 1 | |
| 119344 | 1 | |
| 119321 | 1 | |
| 119305 | 1 | |
| 119302 | 1 | |
| 119298 | 1 | |
| 119294 | 1 | |
| 119292 | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 789.1 KiB |
| City Hotel | |
|---|---|
| Resort Hotel |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.67141302 |
| Min length | 10 |
Characters and Unicode
| Total characters | 127406 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | City Hotel |
|---|---|
| 2nd row | Resort Hotel |
| 3rd row | City Hotel |
| 4th row | City Hotel |
| 5th row | City Hotel |
Common Values
| Value | Count | Frequency (%) |
| City Hotel | 7931 | |
| Resort Hotel | 4008 |
Length
Pie chart
| Value | Count | Frequency (%) |
| hotel | 11939 | |
| city | 7931 | |
| resort | 4008 | 16.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| t | 23878 | |
| o | 15947 | |
| e | 15947 | |
| 11939 | ||
| H | 11939 | |
| l | 11939 | |
| C | 7931 | 6.2% |
| i | 7931 | 6.2% |
| y | 7931 | 6.2% |
| R | 4008 | 3.1% |
| Other values (2) | 8016 | 6.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 91589 | |
| Uppercase Letter | 23878 | 18.7% |
| Space Separator | 11939 | 9.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| t | 23878 | |
| o | 15947 | |
| e | 15947 | |
| l | 11939 | |
| i | 7931 | 8.7% |
| y | 7931 | 8.7% |
| s | 4008 | 4.4% |
| r | 4008 | 4.4% |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 11939 | |
| C | 7931 | |
| R | 4008 | 16.8% |
Space Separator
| Value | Count | Frequency (%) |
| 11939 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 115467 | |
| Common | 11939 | 9.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| t | 23878 | |
| o | 15947 | |
| e | 15947 | |
| H | 11939 | |
| l | 11939 | |
| C | 7931 | 6.9% |
| i | 7931 | 6.9% |
| y | 7931 | 6.9% |
| R | 4008 | 3.5% |
| s | 4008 | 3.5% |
Common
| Value | Count | Frequency (%) |
| 11939 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 127406 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| t | 23878 | |
| o | 15947 | |
| e | 15947 | |
| 11939 | ||
| H | 11939 | |
| l | 11939 | |
| C | 7931 | 6.2% |
| i | 7931 | 6.2% |
| y | 7931 | 6.2% |
| R | 4008 | 3.1% |
| Other values (2) | 8016 | 6.3% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 93.4 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 11939 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 1 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 7526 | |
| 1 | 4413 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 7526 | |
| 1 | 4413 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 7526 | |
| 1 | 4413 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 11939 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 7526 | |
| 1 | 4413 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 11939 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 7526 | |
| 1 | 4413 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11939 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 7526 | |
| 1 | 4413 |
| Distinct | 445 |
|---|---|
| Distinct (%) | 3.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102.2650976 |
| Minimum | 0 |
|---|---|
| Maximum | 629 |
| Zeros | 635 |
| Zeros (%) | 5.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 17 |
| median | 67 |
| Q3 | 159 |
| 95-th percentile | 316 |
| Maximum | 629 |
| Range | 629 |
| Interquartile range (IQR) | 142 |
Descriptive statistics
| Standard deviation | 105.9764844 |
|---|---|
| Coefficient of variation (CV) | 1.036291823 |
| Kurtosis | 1.799286001 |
| Mean | 102.2650976 |
| Median Absolute Deviation (MAD) | 58 |
| Skewness | 1.371569719 |
| Sum | 1220943 |
| Variance | 11231.01524 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 635 | 5.3% |
| 1 | 347 | 2.9% |
| 2 | 216 | 1.8% |
| 3 | 175 | 1.5% |
| 5 | 165 | 1.4% |
| 4 | 150 | 1.3% |
| 6 | 145 | 1.2% |
| 7 | 142 | 1.2% |
| 8 | 116 | 1.0% |
| 10 | 115 | 1.0% |
| Other values (435) | 9733 |
| Value | Count | Frequency (%) |
| 0 | 635 | |
| 1 | 347 | |
| 2 | 216 | 1.8% |
| 3 | 175 | 1.5% |
| 4 | 150 | 1.3% |
| 5 | 165 | 1.4% |
| 6 | 145 | 1.2% |
| 7 | 142 | 1.2% |
| 8 | 116 | 1.0% |
| 9 | 110 | 0.9% |
| Value | Count | Frequency (%) |
| 629 | 3 | |
| 626 | 3 | |
| 622 | 4 | |
| 615 | 2 | |
| 608 | 2 | |
| 605 | 3 | |
| 601 | 1 | < 0.1% |
| 594 | 1 | < 0.1% |
| 587 | 3 | |
| 580 | 1 | < 0.1% |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 93.4 KiB |
| 2016 | |
|---|---|
| 2017 | |
| 2015 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 47756 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2016 |
| 3rd row | 2015 |
| 4th row | 2017 |
| 5th row | 2016 |
Common Values
| Value | Count | Frequency (%) |
| 2016 | 5697 | |
| 2017 | 4081 | |
| 2015 | 2161 | 18.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 2016 | 5697 | |
| 2017 | 4081 | |
| 2015 | 2161 | 18.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 11939 | |
| 0 | 11939 | |
| 1 | 11939 | |
| 6 | 5697 | |
| 7 | 4081 | 8.5% |
| 5 | 2161 | 4.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 47756 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 11939 | |
| 0 | 11939 | |
| 1 | 11939 | |
| 6 | 5697 | |
| 7 | 4081 | 8.5% |
| 5 | 2161 | 4.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 47756 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 11939 | |
| 0 | 11939 | |
| 1 | 11939 | |
| 6 | 5697 | |
| 7 | 4081 | 8.5% |
| 5 | 2161 | 4.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 47756 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 11939 | |
| 0 | 11939 | |
| 1 | 11939 | |
| 6 | 5697 | |
| 7 | 4081 | 8.5% |
| 5 | 2161 | 4.5% |
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 733.4 KiB |
| August | |
|---|---|
| July | |
| May | |
| April | |
| October | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 5.8947148 |
| Min length | 3 |
Characters and Unicode
| Total characters | 70377 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | November |
|---|---|
| 2nd row | April |
| 3rd row | December |
| 4th row | January |
| 5th row | April |
Common Values
| Value | Count | Frequency (%) |
| August | 1346 | |
| July | 1249 | |
| May | 1223 | |
| April | 1117 | |
| October | 1115 | |
| June | 1087 | |
| September | 995 | |
| March | 965 | |
| February | 835 | |
| December | 711 | |
| Other values (2) | 1296 |
Length
| Value | Count | Frequency (%) |
| august | 1346 | |
| july | 1249 | |
| may | 1223 | |
| april | 1117 | |
| october | 1115 | |
| june | 1087 | |
| september | 995 | |
| march | 965 | |
| february | 835 | |
| december | 711 | |
| Other values (2) | 1296 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 9511 | |
| r | 7869 | 11.2% |
| u | 6481 | 9.2% |
| b | 4334 | 6.2% |
| a | 4259 | 6.1% |
| y | 3925 | 5.6% |
| t | 3456 | 4.9% |
| J | 2954 | 4.2% |
| c | 2791 | 4.0% |
| A | 2463 | 3.5% |
| Other values (16) | 22334 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 58438 | |
| Uppercase Letter | 11939 | 17.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 9511 | |
| r | 7869 | |
| u | 6481 | |
| b | 4334 | 7.4% |
| a | 4259 | 7.3% |
| y | 3925 | 6.7% |
| t | 3456 | 5.9% |
| c | 2791 | 4.8% |
| m | 2384 | 4.1% |
| l | 2366 | 4.0% |
| Other values (8) | 11062 |
Uppercase Letter
| Value | Count | Frequency (%) |
| J | 2954 | |
| A | 2463 | |
| M | 2188 | |
| O | 1115 | 9.3% |
| S | 995 | 8.3% |
| F | 835 | 7.0% |
| D | 711 | 6.0% |
| N | 678 | 5.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 70377 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 9511 | |
| r | 7869 | 11.2% |
| u | 6481 | 9.2% |
| b | 4334 | 6.2% |
| a | 4259 | 6.1% |
| y | 3925 | 5.6% |
| t | 3456 | 4.9% |
| J | 2954 | 4.2% |
| c | 2791 | 4.0% |
| A | 2463 | 3.5% |
| Other values (16) | 22334 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 70377 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 9511 | |
| r | 7869 | 11.2% |
| u | 6481 | 9.2% |
| b | 4334 | 6.2% |
| a | 4259 | 6.1% |
| y | 3925 | 5.6% |
| t | 3456 | 4.9% |
| J | 2954 | 4.2% |
| c | 2791 | 4.0% |
| A | 2463 | 3.5% |
| Other values (16) | 22334 |
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.06868247 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 16 |
| median | 27 |
| Q3 | 38 |
| 95-th percentile | 49 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.70172554 |
|---|---|
| Coefficient of variation (CV) | 0.5061836885 |
| Kurtosis | -0.993153523 |
| Mean | 27.06868247 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | 0.009828044899 |
| Sum | 323173 |
| Variance | 187.7372827 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33 | 340 | 2.8% |
| 30 | 317 | 2.7% |
| 20 | 316 | 2.6% |
| 25 | 291 | 2.4% |
| 34 | 290 | 2.4% |
| 32 | 288 | 2.4% |
| 29 | 287 | 2.4% |
| 17 | 286 | 2.4% |
| 18 | 286 | 2.4% |
| 41 | 275 | 2.3% |
| Other values (43) | 8963 |
| Value | Count | Frequency (%) |
| 1 | 106 | |
| 2 | 126 | |
| 3 | 124 | |
| 4 | 175 | |
| 5 | 136 | |
| 6 | 157 | |
| 7 | 214 | |
| 8 | 245 | |
| 9 | 211 | |
| 10 | 189 |
| Value | Count | Frequency (%) |
| 53 | 211 | |
| 52 | 115 | |
| 51 | 92 | |
| 50 | 147 | |
| 49 | 187 | |
| 48 | 156 | |
| 47 | 150 | |
| 46 | 161 | |
| 45 | 203 | |
| 44 | 223 |
arrival_date_day_of_month
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.97470475 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 24 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 8.742890086 |
|---|---|
| Coefficient of variation (CV) | 0.5472958795 |
| Kurtosis | -1.173654697 |
| Mean | 15.97470475 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.02684347686 |
| Sum | 190722 |
| Variance | 76.43812706 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17 | 468 | 3.9% |
| 15 | 453 | 3.8% |
| 24 | 443 | 3.7% |
| 5 | 432 | 3.6% |
| 12 | 424 | 3.6% |
| 20 | 420 | 3.5% |
| 19 | 416 | 3.5% |
| 28 | 414 | 3.5% |
| 27 | 410 | 3.4% |
| 25 | 409 | 3.4% |
| Other values (21) | 7650 |
| Value | Count | Frequency (%) |
| 1 | 363 | |
| 2 | 363 | |
| 3 | 392 | |
| 4 | 342 | |
| 5 | 432 | |
| 6 | 350 | |
| 7 | 362 | |
| 8 | 386 | |
| 9 | 401 | |
| 10 | 371 |
| Value | Count | Frequency (%) |
| 31 | 219 | |
| 30 | 388 | |
| 29 | 370 | |
| 28 | 414 | |
| 27 | 410 | |
| 26 | 385 | |
| 25 | 409 | |
| 24 | 443 | |
| 23 | 367 | |
| 22 | 360 |
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9141469135 |
| Minimum | 0 |
|---|---|
| Maximum | 9 |
| Zeros | 5276 |
| Zeros (%) | 44.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 0.987058179 |
|---|---|
| Coefficient of variation (CV) | 1.079758805 |
| Kurtosis | 3.016416053 |
| Mean | 0.9141469135 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.143543888 |
| Sum | 10914 |
| Variance | 0.9742838487 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5276 | |
| 2 | 3273 | |
| 1 | 3047 | |
| 4 | 175 | 1.5% |
| 3 | 135 | 1.1% |
| 6 | 18 | 0.2% |
| 8 | 9 | 0.1% |
| 5 | 4 | < 0.1% |
| 7 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 5276 | |
| 1 | 3047 | |
| 2 | 3273 | |
| 3 | 135 | 1.1% |
| 4 | 175 | 1.5% |
| 5 | 4 | < 0.1% |
| 6 | 18 | 0.2% |
| 7 | 1 | < 0.1% |
| 8 | 9 | 0.1% |
| 9 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 9 | 1 | < 0.1% |
| 8 | 9 | 0.1% |
| 7 | 1 | < 0.1% |
| 6 | 18 | 0.2% |
| 5 | 4 | < 0.1% |
| 4 | 175 | 1.5% |
| 3 | 135 | 1.1% |
| 2 | 3273 | |
| 1 | 3047 | |
| 0 | 5276 |
| Distinct | 21 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.487729291 |
| Minimum | 0 |
|---|---|
| Maximum | 22 |
| Zeros | 771 |
| Zeros (%) | 6.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 22 |
| Range | 22 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.869170221 |
|---|---|
| Coefficient of variation (CV) | 0.7513559566 |
| Kurtosis | 13.4165766 |
| Mean | 2.487729291 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.401236979 |
| Sum | 29701 |
| Variance | 3.493797315 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 3434 | |
| 1 | 2997 | |
| 3 | 2230 | |
| 5 | 1081 | 9.1% |
| 4 | 948 | 7.9% |
| 0 | 771 | 6.5% |
| 6 | 139 | 1.2% |
| 7 | 114 | 1.0% |
| 10 | 88 | 0.7% |
| 8 | 73 | 0.6% |
| Other values (11) | 64 | 0.5% |
| Value | Count | Frequency (%) |
| 0 | 771 | 6.5% |
| 1 | 2997 | |
| 2 | 3434 | |
| 3 | 2230 | |
| 4 | 948 | 7.9% |
| 5 | 1081 | 9.1% |
| 6 | 139 | 1.2% |
| 7 | 114 | 1.0% |
| 8 | 73 | 0.6% |
| 9 | 23 | 0.2% |
| Value | Count | Frequency (%) |
| 22 | 2 | < 0.1% |
| 21 | 4 | < 0.1% |
| 20 | 4 | < 0.1% |
| 19 | 3 | < 0.1% |
| 16 | 1 | < 0.1% |
| 15 | 12 | |
| 14 | 4 | < 0.1% |
| 13 | 3 | < 0.1% |
| 12 | 2 | < 0.1% |
| 11 | 6 |
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.853840355 |
| Minimum | 0 |
|---|---|
| Maximum | 40 |
| Zeros | 42 |
| Zeros (%) | 0.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 40 |
| Range | 40 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6048854144 |
|---|---|
| Coefficient of variation (CV) | 0.3262877587 |
| Kurtosis | 1324.471113 |
| Mean | 1.853840355 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 20.76322339 |
| Sum | 22133 |
| Variance | 0.3658863645 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 8911 | |
| 1 | 2346 | 19.6% |
| 3 | 632 | 5.3% |
| 0 | 42 | 0.4% |
| 4 | 6 | 0.1% |
| 5 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 42 | 0.4% |
| 1 | 2346 | 19.6% |
| 2 | 8911 | |
| 3 | 632 | 5.3% |
| 4 | 6 | 0.1% |
| 5 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 40 | 1 | < 0.1% |
| 5 | 1 | < 0.1% |
| 4 | 6 | 0.1% |
| 3 | 632 | 5.3% |
| 2 | 8911 | |
| 1 | 2346 | 19.6% |
| 0 | 42 | 0.4% |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 93.4 KiB |
| 0.0 | |
|---|---|
| 1.0 | 468 |
| 2.0 | 365 |
| 3.0 | 5 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 35817 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 11101 | |
| 1.0 | 468 | 3.9% |
| 2.0 | 365 | 3.1% |
| 3.0 | 5 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0.0 | 11101 | |
| 1.0 | 468 | 3.9% |
| 2.0 | 365 | 3.1% |
| 3.0 | 5 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 23040 | |
| . | 11939 | |
| 1 | 468 | 1.3% |
| 2 | 365 | 1.0% |
| 3 | 5 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 23878 | |
| Other Punctuation | 11939 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 23040 | |
| 1 | 468 | 2.0% |
| 2 | 365 | 1.5% |
| 3 | 5 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 11939 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 35817 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 23040 | |
| . | 11939 | |
| 1 | 468 | 1.3% |
| 2 | 365 | 1.0% |
| 3 | 5 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 35817 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 23040 | |
| . | 11939 | |
| 1 | 468 | 1.3% |
| 2 | 365 | 1.0% |
| 3 | 5 | < 0.1% |
babies
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 93.4 KiB |
| 0 | |
|---|---|
| 1 | 105 |
| 2 | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 11939 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 11832 | |
| 1 | 105 | 0.9% |
| 2 | 2 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 11832 | |
| 1 | 105 | 0.9% |
| 2 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 11832 | |
| 1 | 105 | 0.9% |
| 2 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 11939 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 11832 | |
| 1 | 105 | 0.9% |
| 2 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 11939 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 11832 | |
| 1 | 105 | 0.9% |
| 2 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11939 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 11832 | |
| 1 | 105 | 0.9% |
| 2 | 2 | < 0.1% |
meal
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 688.7 KiB |
| BB | |
|---|---|
| HB | |
| SC | |
| Undefined | 99 |
| FB | 88 |
Length
| Max length | 9 |
|---|---|
| Median length | 2 |
| Mean length | 2.058045062 |
| Min length | 2 |
Characters and Unicode
| Total characters | 24571 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BB |
|---|---|
| 2nd row | BB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
Common Values
| Value | Count | Frequency (%) |
| BB | 9222 | |
| HB | 1446 | 12.1% |
| SC | 1084 | 9.1% |
| Undefined | 99 | 0.8% |
| FB | 88 | 0.7% |
Length
Pie chart
| Value | Count | Frequency (%) |
| bb | 9222 | |
| hb | 1446 | 12.1% |
| sc | 1084 | 9.1% |
| undefined | 99 | 0.8% |
| fb | 88 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 19978 | |
| H | 1446 | 5.9% |
| S | 1084 | 4.4% |
| C | 1084 | 4.4% |
| n | 198 | 0.8% |
| d | 198 | 0.8% |
| e | 198 | 0.8% |
| U | 99 | 0.4% |
| f | 99 | 0.4% |
| i | 99 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 23779 | |
| Lowercase Letter | 792 | 3.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 19978 | |
| H | 1446 | 6.1% |
| S | 1084 | 4.6% |
| C | 1084 | 4.6% |
| U | 99 | 0.4% |
| F | 88 | 0.4% |
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 198 | |
| d | 198 | |
| e | 198 | |
| f | 99 | |
| i | 99 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 24571 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 19978 | |
| H | 1446 | 5.9% |
| S | 1084 | 4.4% |
| C | 1084 | 4.4% |
| n | 198 | 0.8% |
| d | 198 | 0.8% |
| e | 198 | 0.8% |
| U | 99 | 0.4% |
| f | 99 | 0.4% |
| i | 99 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 24571 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| B | 19978 | |
| H | 1446 | 5.9% |
| S | 1084 | 4.4% |
| C | 1084 | 4.4% |
| n | 198 | 0.8% |
| d | 198 | 0.8% |
| e | 198 | 0.8% |
| U | 99 | 0.4% |
| f | 99 | 0.4% |
| i | 99 | 0.4% |
| Distinct | 109 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 48 |
| Missing (%) | 0.4% |
| Memory size | 698.2 KiB |
| PRT | |
|---|---|
| GBR | |
| FRA | |
| ESP | |
| DEU | |
| Other values (104) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.989235556 |
| Min length | 2 |
Characters and Unicode
| Total characters | 35545 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 24 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | FRA |
|---|---|
| 2nd row | PRT |
| 3rd row | FRA |
| 4th row | GBR |
| 5th row | FRA |
Common Values
| Value | Count | Frequency (%) |
| PRT | 4880 | |
| GBR | 1165 | 9.8% |
| FRA | 1009 | 8.5% |
| ESP | 866 | 7.3% |
| DEU | 729 | 6.1% |
| ITA | 404 | 3.4% |
| IRL | 323 | 2.7% |
| NLD | 223 | 1.9% |
| BRA | 222 | 1.9% |
| BEL | 213 | 1.8% |
| Other values (99) | 1857 | 15.6% |
Length
| Value | Count | Frequency (%) |
| prt | 4880 | |
| gbr | 1165 | 9.8% |
| fra | 1009 | 8.5% |
| esp | 866 | 7.3% |
| deu | 729 | 6.1% |
| ita | 404 | 3.4% |
| irl | 323 | 2.7% |
| nld | 223 | 1.9% |
| bra | 222 | 1.9% |
| bel | 213 | 1.8% |
| Other values (99) | 1857 | 15.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 8033 | |
| P | 5896 | |
| T | 5485 | |
| E | 2161 | 6.1% |
| A | 2135 | 6.0% |
| B | 1632 | 4.6% |
| S | 1410 | 4.0% |
| U | 1353 | 3.8% |
| G | 1262 | 3.6% |
| F | 1057 | 3.0% |
| Other values (16) | 5121 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 35545 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 8033 | |
| P | 5896 | |
| T | 5485 | |
| E | 2161 | 6.1% |
| A | 2135 | 6.0% |
| B | 1632 | 4.6% |
| S | 1410 | 4.0% |
| U | 1353 | 3.8% |
| G | 1262 | 3.6% |
| F | 1057 | 3.0% |
| Other values (16) | 5121 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 35545 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 8033 | |
| P | 5896 | |
| T | 5485 | |
| E | 2161 | 6.1% |
| A | 2135 | 6.0% |
| B | 1632 | 4.6% |
| S | 1410 | 4.0% |
| U | 1353 | 3.8% |
| G | 1262 | 3.6% |
| F | 1057 | 3.0% |
| Other values (16) | 5121 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 35545 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| R | 8033 | |
| P | 5896 | |
| T | 5485 | |
| E | 2161 | 6.1% |
| A | 2135 | 6.0% |
| B | 1632 | 4.6% |
| S | 1410 | 4.0% |
| U | 1353 | 3.8% |
| G | 1262 | 3.6% |
| F | 1057 | 3.0% |
| Other values (16) | 5121 |
| Distinct | 7 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 770.0 KiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Groups | |
| Direct | |
| Corporate | 542 |
| Other values (2) | 103 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.027724265 |
| Min length | 6 |
Characters and Unicode
| Total characters | 107782 |
|---|---|
| Distinct characters | 24 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Online TA |
| 3rd row | Offline TA/TO |
| 4th row | Online TA |
| 5th row | Direct |
Common Values
| Value | Count | Frequency (%) |
| Online TA | 5692 | |
| Offline TA/TO | 2410 | |
| Groups | 1957 | 16.4% |
| Direct | 1235 | 10.3% |
| Corporate | 542 | 4.5% |
| Complementary | 74 | 0.6% |
| Aviation | 29 | 0.2% |
Length
Pie chart
| Value | Count | Frequency (%) |
| online | 5692 | |
| ta | 5692 | |
| ta/to | 2410 | |
| offline | 2410 | |
| groups | 1957 | 9.8% |
| direct | 1235 | 6.2% |
| corporate | 542 | 2.7% |
| complementary | 74 | 0.4% |
| aviation | 29 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 13897 | |
| O | 10512 | |
| T | 10512 | |
| e | 10027 | |
| i | 9395 | |
| l | 8176 | |
| A | 8131 | |
| 8102 | ||
| f | 4820 | 4.5% |
| r | 4350 | 4.0% |
| Other values (14) | 19860 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 64307 | |
| Uppercase Letter | 32963 | |
| Space Separator | 8102 | 7.5% |
| Other Punctuation | 2410 | 2.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 13897 | |
| e | 10027 | |
| i | 9395 | |
| l | 8176 | |
| f | 4820 | 7.5% |
| r | 4350 | 6.8% |
| o | 3144 | 4.9% |
| p | 2573 | 4.0% |
| u | 1957 | 3.0% |
| s | 1957 | 3.0% |
| Other values (6) | 4011 | 6.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 10512 | |
| T | 10512 | |
| A | 8131 | |
| G | 1957 | 5.9% |
| D | 1235 | 3.7% |
| C | 616 | 1.9% |
Space Separator
| Value | Count | Frequency (%) |
| 8102 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 2410 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 97270 | |
| Common | 10512 | 9.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 13897 | |
| O | 10512 | |
| T | 10512 | |
| e | 10027 | |
| i | 9395 | |
| l | 8176 | |
| A | 8131 | |
| f | 4820 | 5.0% |
| r | 4350 | 4.5% |
| o | 3144 | 3.2% |
| Other values (12) | 14306 |
Common
| Value | Count | Frequency (%) |
| 8102 | ||
| / | 2410 | 22.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 107782 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 13897 | |
| O | 10512 | |
| T | 10512 | |
| e | 10027 | |
| i | 9395 | |
| l | 8176 | |
| A | 8131 | |
| 8102 | ||
| f | 4820 | 4.5% |
| r | 4350 | 4.0% |
| Other values (14) | 19860 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 726.9 KiB |
| TA/TO | |
|---|---|
| Direct | |
| Corporate | 652 |
| GDS | 17 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.337968004 |
| Min length | 3 |
Characters and Unicode
| Total characters | 63730 |
|---|---|
| Distinct characters | 16 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | TA/TO |
| 3rd row | TA/TO |
| 4th row | TA/TO |
| 5th row | Direct |
Common Values
| Value | Count | Frequency (%) |
| TA/TO | 9809 | |
| Direct | 1461 | 12.2% |
| Corporate | 652 | 5.5% |
| GDS | 17 | 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| ta/to | 9809 | |
| direct | 1461 | 12.2% |
| corporate | 652 | 5.5% |
| gds | 17 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 19618 | |
| A | 9809 | |
| / | 9809 | |
| O | 9809 | |
| r | 2765 | 4.3% |
| e | 2113 | 3.3% |
| t | 2113 | 3.3% |
| D | 1478 | 2.3% |
| i | 1461 | 2.3% |
| c | 1461 | 2.3% |
| Other values (6) | 3294 | 5.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 41400 | |
| Lowercase Letter | 12521 | 19.6% |
| Other Punctuation | 9809 | 15.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 2765 | |
| e | 2113 | |
| t | 2113 | |
| i | 1461 | |
| c | 1461 | |
| o | 1304 | |
| p | 652 | 5.2% |
| a | 652 | 5.2% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 19618 | |
| A | 9809 | |
| O | 9809 | |
| D | 1478 | 3.6% |
| C | 652 | 1.6% |
| G | 17 | < 0.1% |
| S | 17 | < 0.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 9809 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 53921 | |
| Common | 9809 | 15.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| T | 19618 | |
| A | 9809 | |
| O | 9809 | |
| r | 2765 | 5.1% |
| e | 2113 | 3.9% |
| t | 2113 | 3.9% |
| D | 1478 | 2.7% |
| i | 1461 | 2.7% |
| c | 1461 | 2.7% |
| o | 1304 | 2.4% |
| Other values (5) | 1990 | 3.7% |
Common
| Value | Count | Frequency (%) |
| / | 9809 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 63730 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| T | 19618 | |
| A | 9809 | |
| / | 9809 | |
| O | 9809 | |
| r | 2765 | 4.3% |
| e | 2113 | 3.3% |
| t | 2113 | 3.3% |
| D | 1478 | 2.3% |
| i | 1461 | 2.3% |
| c | 1461 | 2.3% |
| Other values (6) | 3294 | 5.2% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 93.4 KiB |
| 0 | |
|---|---|
| 1 | 377 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 11939 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 11562 | |
| 1 | 377 | 3.2% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 11562 | |
| 1 | 377 | 3.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 11562 | |
| 1 | 377 | 3.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 11939 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 11562 | |
| 1 | 377 | 3.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 11939 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 11562 | |
| 1 | 377 | 3.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11939 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 11562 | |
| 1 | 377 | 3.2% |
| Distinct | 12 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.08895217355 |
| Minimum | 0 |
|---|---|
| Maximum | 26 |
| Zeros | 11325 |
| Zeros (%) | 94.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.9283031604 |
|---|---|
| Coefficient of variation (CV) | 10.43598063 |
| Kurtosis | 617.4229725 |
| Mean | 0.08895217355 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 23.75659833 |
| Sum | 1062 |
| Variance | 0.8617467576 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 11325 | |
| 1 | 568 | 4.8% |
| 2 | 15 | 0.1% |
| 3 | 6 | 0.1% |
| 24 | 6 | 0.1% |
| 26 | 5 | < 0.1% |
| 11 | 4 | < 0.1% |
| 6 | 3 | < 0.1% |
| 25 | 3 | < 0.1% |
| 4 | 2 | < 0.1% |
| Other values (2) | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 11325 | |
| 1 | 568 | 4.8% |
| 2 | 15 | 0.1% |
| 3 | 6 | 0.1% |
| 4 | 2 | < 0.1% |
| 6 | 3 | < 0.1% |
| 11 | 4 | < 0.1% |
| 13 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| 24 | 6 | 0.1% |
| Value | Count | Frequency (%) |
| 26 | 5 | < 0.1% |
| 25 | 3 | < 0.1% |
| 24 | 6 | 0.1% |
| 14 | 1 | < 0.1% |
| 13 | 1 | < 0.1% |
| 11 | 4 | < 0.1% |
| 6 | 3 | < 0.1% |
| 4 | 2 | < 0.1% |
| 3 | 6 | 0.1% |
| 2 | 15 |
previous_bookings_not_canceled
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 29 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.140882821 |
| Minimum | 0 |
|---|---|
| Maximum | 59 |
| Zeros | 11560 |
| Zeros (%) | 96.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 59 |
| Range | 59 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.465840309 |
|---|---|
| Coefficient of variation (CV) | 10.40467744 |
| Kurtosis | 661.5111628 |
| Mean | 0.140882821 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 21.99555117 |
| Sum | 1682 |
| Variance | 2.148687812 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 11560 | |
| 1 | 164 | 1.4% |
| 2 | 57 | 0.5% |
| 3 | 39 | 0.3% |
| 4 | 18 | 0.2% |
| 7 | 14 | 0.1% |
| 5 | 14 | 0.1% |
| 8 | 12 | 0.1% |
| 6 | 12 | 0.1% |
| 11 | 8 | 0.1% |
| Other values (19) | 41 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 11560 | |
| 1 | 164 | 1.4% |
| 2 | 57 | 0.5% |
| 3 | 39 | 0.3% |
| 4 | 18 | 0.2% |
| 5 | 14 | 0.1% |
| 6 | 12 | 0.1% |
| 7 | 14 | 0.1% |
| 8 | 12 | 0.1% |
| 9 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 59 | 1 | |
| 58 | 1 | |
| 45 | 1 | |
| 44 | 1 | |
| 33 | 1 | |
| 31 | 1 | |
| 28 | 1 | |
| 25 | 2 | |
| 24 | 2 | |
| 21 | 2 |
| Distinct | 8 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 676.4 KiB |
| A | |
|---|---|
| D | |
| E | 647 |
| F | 266 |
| G | 191 |
| Other values (3) | 290 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 11939 |
|---|---|
| Distinct characters | 8 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | D |
|---|---|
| 2nd row | E |
| 3rd row | A |
| 4th row | D |
| 5th row | D |
Common Values
| Value | Count | Frequency (%) |
| A | 8612 | |
| D | 1933 | 16.2% |
| E | 647 | 5.4% |
| F | 266 | 2.2% |
| G | 191 | 1.6% |
| B | 124 | 1.0% |
| C | 111 | 0.9% |
| H | 55 | 0.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| a | 8612 | |
| d | 1933 | 16.2% |
| e | 647 | 5.4% |
| f | 266 | 2.2% |
| g | 191 | 1.6% |
| b | 124 | 1.0% |
| c | 111 | 0.9% |
| h | 55 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 8612 | |
| D | 1933 | 16.2% |
| E | 647 | 5.4% |
| F | 266 | 2.2% |
| G | 191 | 1.6% |
| B | 124 | 1.0% |
| C | 111 | 0.9% |
| H | 55 | 0.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 11939 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 8612 | |
| D | 1933 | 16.2% |
| E | 647 | 5.4% |
| F | 266 | 2.2% |
| G | 191 | 1.6% |
| B | 124 | 1.0% |
| C | 111 | 0.9% |
| H | 55 | 0.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11939 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 8612 | |
| D | 1933 | 16.2% |
| E | 647 | 5.4% |
| F | 266 | 2.2% |
| G | 191 | 1.6% |
| B | 124 | 1.0% |
| C | 111 | 0.9% |
| H | 55 | 0.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11939 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 8612 | |
| D | 1933 | 16.2% |
| E | 647 | 5.4% |
| F | 266 | 2.2% |
| G | 191 | 1.6% |
| B | 124 | 1.0% |
| C | 111 | 0.9% |
| H | 55 | 0.5% |
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 676.4 KiB |
| A | |
|---|---|
| D | |
| E | |
| F | 354 |
| C | 250 |
| Other values (5) | 593 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 11939 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | D |
|---|---|
| 2nd row | E |
| 3rd row | A |
| 4th row | D |
| 5th row | D |
Common Values
| Value | Count | Frequency (%) |
| A | 7419 | |
| D | 2555 | 21.4% |
| E | 768 | 6.4% |
| F | 354 | 3.0% |
| C | 250 | 2.1% |
| G | 241 | 2.0% |
| B | 229 | 1.9% |
| H | 65 | 0.5% |
| I | 37 | 0.3% |
| K | 21 | 0.2% |
Length
Pie chart
| Value | Count | Frequency (%) |
| a | 7419 | |
| d | 2555 | 21.4% |
| e | 768 | 6.4% |
| f | 354 | 3.0% |
| c | 250 | 2.1% |
| g | 241 | 2.0% |
| b | 229 | 1.9% |
| h | 65 | 0.5% |
| i | 37 | 0.3% |
| k | 21 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 7419 | |
| D | 2555 | 21.4% |
| E | 768 | 6.4% |
| F | 354 | 3.0% |
| C | 250 | 2.1% |
| G | 241 | 2.0% |
| B | 229 | 1.9% |
| H | 65 | 0.5% |
| I | 37 | 0.3% |
| K | 21 | 0.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 11939 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 7419 | |
| D | 2555 | 21.4% |
| E | 768 | 6.4% |
| F | 354 | 3.0% |
| C | 250 | 2.1% |
| G | 241 | 2.0% |
| B | 229 | 1.9% |
| H | 65 | 0.5% |
| I | 37 | 0.3% |
| K | 21 | 0.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 11939 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| A | 7419 | |
| D | 2555 | 21.4% |
| E | 768 | 6.4% |
| F | 354 | 3.0% |
| C | 250 | 2.1% |
| G | 241 | 2.0% |
| B | 229 | 1.9% |
| H | 65 | 0.5% |
| I | 37 | 0.3% |
| K | 21 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11939 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| A | 7419 | |
| D | 2555 | 21.4% |
| E | 768 | 6.4% |
| F | 354 | 3.0% |
| C | 250 | 2.1% |
| G | 241 | 2.0% |
| B | 229 | 1.9% |
| H | 65 | 0.5% |
| I | 37 | 0.3% |
| K | 21 | 0.2% |
| Distinct | 10 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2175224056 |
| Minimum | 0 |
|---|---|
| Maximum | 9 |
| Zeros | 10139 |
| Zeros (%) | 84.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 9 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6183174707 |
|---|---|
| Coefficient of variation (CV) | 2.842546124 |
| Kurtosis | 27.64457801 |
| Mean | 0.2175224056 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.278352626 |
| Sum | 2597 |
| Variance | 0.3823164946 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 10139 | |
| 1 | 1271 | 10.6% |
| 2 | 371 | 3.1% |
| 3 | 97 | 0.8% |
| 4 | 36 | 0.3% |
| 5 | 12 | 0.1% |
| 6 | 7 | 0.1% |
| 7 | 3 | < 0.1% |
| 9 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 10139 | |
| 1 | 1271 | 10.6% |
| 2 | 371 | 3.1% |
| 3 | 97 | 0.8% |
| 4 | 36 | 0.3% |
| 5 | 12 | 0.1% |
| 6 | 7 | 0.1% |
| 7 | 3 | < 0.1% |
| 8 | 1 | < 0.1% |
| 9 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 9 | 2 | < 0.1% |
| 8 | 1 | < 0.1% |
| 7 | 3 | < 0.1% |
| 6 | 7 | 0.1% |
| 5 | 12 | 0.1% |
| 4 | 36 | 0.3% |
| 3 | 97 | 0.8% |
| 2 | 371 | 3.1% |
| 1 | 1271 | 10.6% |
| 0 | 10139 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 781.3 KiB |
| No Deposit | |
|---|---|
| Non Refund | |
| Refundable | 20 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 119390 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
Common Values
| Value | Count | Frequency (%) |
| No Deposit | 10482 | |
| Non Refund | 1437 | 12.0% |
| Refundable | 20 | 0.2% |
Length
Pie chart
| Value | Count | Frequency (%) |
| deposit | 10482 | |
| no | 10482 | |
| refund | 1437 | 6.0% |
| non | 1437 | 6.0% |
| refundable | 20 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 22401 | |
| e | 11959 | |
| N | 11919 | |
| 11919 | ||
| D | 10482 | |
| p | 10482 | |
| s | 10482 | |
| i | 10482 | |
| t | 10482 | |
| n | 2894 | 2.4% |
| Other values (7) | 5888 | 4.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 83613 | |
| Uppercase Letter | 23858 | 20.0% |
| Space Separator | 11919 | 10.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| o | 22401 | |
| e | 11959 | |
| p | 10482 | |
| s | 10482 | |
| i | 10482 | |
| t | 10482 | |
| n | 2894 | 3.5% |
| f | 1457 | 1.7% |
| u | 1457 | 1.7% |
| d | 1457 | 1.7% |
| Other values (3) | 60 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| N | 11919 | |
| D | 10482 | |
| R | 1457 | 6.1% |
Space Separator
| Value | Count | Frequency (%) |
| 11919 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 107471 | |
| Common | 11919 | 10.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| o | 22401 | |
| e | 11959 | |
| N | 11919 | |
| D | 10482 | |
| p | 10482 | |
| s | 10482 | |
| i | 10482 | |
| t | 10482 | |
| n | 2894 | 2.7% |
| R | 1457 | 1.4% |
| Other values (6) | 4431 | 4.1% |
Common
| Value | Count | Frequency (%) |
| 11919 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 119390 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| o | 22401 | |
| e | 11959 | |
| N | 11919 | |
| 11919 | ||
| D | 10482 | |
| p | 10482 | |
| s | 10482 | |
| i | 10482 | |
| t | 10482 | |
| n | 2894 | 2.4% |
| Other values (7) | 5888 | 4.9% |
| Distinct | 223 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 1635 |
| Missing (%) | 13.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 86.44817547 |
| Minimum | 1 |
|---|---|
| Maximum | 531 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 9 |
| median | 14 |
| Q3 | 229 |
| 95-th percentile | 250 |
| Maximum | 531 |
| Range | 530 |
| Interquartile range (IQR) | 220 |
Descriptive statistics
| Standard deviation | 110.432807 |
|---|---|
| Coefficient of variation (CV) | 1.277445203 |
| Kurtosis | 0.01658087489 |
| Mean | 86.44817547 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 1.095463857 |
| Sum | 890762 |
| Variance | 12195.40487 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9 | 3265 | |
| 240 | 1392 | |
| 1 | 664 | 5.6% |
| 14 | 344 | 2.9% |
| 6 | 328 | 2.7% |
| 7 | 320 | 2.7% |
| 250 | 299 | 2.5% |
| 28 | 176 | 1.5% |
| 241 | 170 | 1.4% |
| 8 | 157 | 1.3% |
| Other values (213) | 3189 | |
| (Missing) | 1635 |
| Value | Count | Frequency (%) |
| 1 | 664 | 5.6% |
| 2 | 21 | 0.2% |
| 3 | 117 | 1.0% |
| 4 | 7 | 0.1% |
| 5 | 38 | 0.3% |
| 6 | 328 | 2.7% |
| 7 | 320 | 2.7% |
| 8 | 157 | 1.3% |
| 9 | 3265 | |
| 10 | 22 | 0.2% |
| Value | Count | Frequency (%) |
| 531 | 8 | |
| 527 | 3 | < 0.1% |
| 526 | 1 | < 0.1% |
| 509 | 1 | < 0.1% |
| 502 | 2 | < 0.1% |
| 495 | 6 | |
| 493 | 4 | |
| 492 | 4 | |
| 480 | 1 | < 0.1% |
| 479 | 3 | < 0.1% |
| Distinct | 163 |
|---|---|
| Distinct (%) | 23.4% |
| Missing | 11241 |
| Missing (%) | 94.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 189 |
| Minimum | 9 |
|---|---|
| Maximum | 543 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 67 |
| median | 178 |
| Q3 | 260 |
| 95-th percentile | 428.75 |
| Maximum | 543 |
| Range | 534 |
| Interquartile range (IQR) | 193 |
Descriptive statistics
| Standard deviation | 131.6184216 |
|---|---|
| Coefficient of variation (CV) | 0.6963937649 |
| Kurtosis | -0.4128483484 |
| Mean | 189 |
| Median Absolute Deviation (MAD) | 103 |
| Skewness | 0.6395076039 |
| Sum | 131922 |
| Variance | 17323.4089 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 40 | 91 | 0.8% |
| 223 | 81 | 0.7% |
| 45 | 28 | 0.2% |
| 153 | 26 | 0.2% |
| 67 | 25 | 0.2% |
| 281 | 18 | 0.2% |
| 219 | 14 | 0.1% |
| 154 | 14 | 0.1% |
| 174 | 13 | 0.1% |
| 233 | 12 | 0.1% |
| Other values (153) | 376 | 3.1% |
| (Missing) | 11241 |
| Value | Count | Frequency (%) |
| 9 | 3 | |
| 11 | 1 | < 0.1% |
| 12 | 2 | < 0.1% |
| 14 | 1 | < 0.1% |
| 16 | 1 | < 0.1% |
| 20 | 5 | |
| 28 | 2 | < 0.1% |
| 31 | 2 | < 0.1% |
| 38 | 3 | |
| 39 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 543 | 1 | < 0.1% |
| 531 | 1 | < 0.1% |
| 528 | 1 | < 0.1% |
| 525 | 2 | < 0.1% |
| 521 | 1 | < 0.1% |
| 514 | 1 | < 0.1% |
| 512 | 1 | < 0.1% |
| 506 | 1 | < 0.1% |
| 504 | 1 | < 0.1% |
| 498 | 11 |
| Distinct | 87 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.492336042 |
| Minimum | 0 |
|---|---|
| Maximum | 391 |
| Zeros | 11561 |
| Zeros (%) | 96.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 391 |
| Range | 391 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 19.18989246 |
|---|---|
| Coefficient of variation (CV) | 7.699560629 |
| Kurtosis | 186.7271495 |
| Mean | 2.492336042 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.16410697 |
| Sum | 29756 |
| Variance | 368.2519726 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 11561 | |
| 39 | 39 | 0.3% |
| 58 | 23 | 0.2% |
| 44 | 13 | 0.1% |
| 31 | 11 | 0.1% |
| 3 | 10 | 0.1% |
| 63 | 10 | 0.1% |
| 69 | 10 | 0.1% |
| 62 | 9 | 0.1% |
| 187 | 9 | 0.1% |
| Other values (77) | 244 | 2.0% |
| Value | Count | Frequency (%) |
| 0 | 11561 | |
| 1 | 2 | < 0.1% |
| 3 | 10 | 0.1% |
| 4 | 1 | < 0.1% |
| 6 | 3 | < 0.1% |
| 10 | 1 | < 0.1% |
| 11 | 1 | < 0.1% |
| 14 | 1 | < 0.1% |
| 15 | 4 | < 0.1% |
| 17 | 7 | 0.1% |
| Value | Count | Frequency (%) |
| 391 | 8 | |
| 330 | 5 | |
| 236 | 4 | |
| 224 | 1 | < 0.1% |
| 223 | 6 | |
| 215 | 1 | < 0.1% |
| 207 | 4 | |
| 187 | 9 | |
| 178 | 1 | < 0.1% |
| 176 | 6 |
customer_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 783.8 KiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 404 |
| Group | 64 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 10.21165927 |
| Min length | 5 |
Characters and Unicode
| Total characters | 121917 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient |
|---|---|
| 2nd row | Transient |
| 3rd row | Transient |
| 4th row | Transient |
| 5th row | Transient |
Common Values
| Value | Count | Frequency (%) |
| Transient | 8950 | |
| Transient-Party | 2521 | 21.1% |
| Contract | 404 | 3.4% |
| Group | 64 | 0.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| transient | 8950 | |
| transient-party | 2521 | 21.1% |
| contract | 404 | 3.4% |
| group | 64 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 23346 | |
| t | 14800 | |
| r | 14460 | |
| a | 14396 | |
| T | 11471 | |
| s | 11471 | |
| i | 11471 | |
| e | 11471 | |
| - | 2521 | 2.1% |
| P | 2521 | 2.1% |
| Other values (7) | 3989 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 104936 | |
| Uppercase Letter | 14460 | 11.9% |
| Dash Punctuation | 2521 | 2.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| n | 23346 | |
| t | 14800 | |
| r | 14460 | |
| a | 14396 | |
| s | 11471 | |
| i | 11471 | |
| e | 11471 | |
| y | 2521 | 2.4% |
| o | 468 | 0.4% |
| c | 404 | 0.4% |
| Other values (2) | 128 | 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| T | 11471 | |
| P | 2521 | 17.4% |
| C | 404 | 2.8% |
| G | 64 | 0.4% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2521 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 119396 | |
| Common | 2521 | 2.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| n | 23346 | |
| t | 14800 | |
| r | 14460 | |
| a | 14396 | |
| T | 11471 | |
| s | 11471 | |
| i | 11471 | |
| e | 11471 | |
| P | 2521 | 2.1% |
| y | 2521 | 2.1% |
| Other values (6) | 1468 | 1.2% |
Common
| Value | Count | Frequency (%) |
| - | 2521 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 121917 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| n | 23346 | |
| t | 14800 | |
| r | 14460 | |
| a | 14396 | |
| T | 11471 | |
| s | 11471 | |
| i | 11471 | |
| e | 11471 | |
| - | 2521 | 2.1% |
| P | 2521 | 2.1% |
| Other values (7) | 3989 | 3.3% |
| Distinct | 2440 |
|---|---|
| Distinct (%) | 20.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101.8099422 |
| Minimum | 0 |
|---|---|
| Maximum | 392 |
| Zeros | 204 |
| Zeros (%) | 1.7% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 38 |
| Q1 | 69.43 |
| median | 95 |
| Q3 | 126 |
| 95-th percentile | 192 |
| Maximum | 392 |
| Range | 392 |
| Interquartile range (IQR) | 56.57 |
Descriptive statistics
| Standard deviation | 48.36573863 |
|---|---|
| Coefficient of variation (CV) | 0.4750590913 |
| Kurtosis | 1.939955893 |
| Mean | 101.8099422 |
| Median Absolute Deviation (MAD) | 28 |
| Skewness | 0.9767056269 |
| Sum | 1215508.9 |
| Variance | 2339.244673 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 62 | 332 | 2.8% |
| 75 | 280 | 2.3% |
| 90 | 229 | 1.9% |
| 65 | 222 | 1.9% |
| 0 | 204 | 1.7% |
| 80 | 195 | 1.6% |
| 95 | 179 | 1.5% |
| 120 | 164 | 1.4% |
| 110 | 153 | 1.3% |
| 85 | 150 | 1.3% |
| Other values (2430) | 9831 |
| Value | Count | Frequency (%) |
| 0 | 204 | |
| 1 | 3 | < 0.1% |
| 1.56 | 1 | < 0.1% |
| 1.8 | 1 | < 0.1% |
| 2 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 1 | < 0.1% |
| 6 | 8 | 0.1% |
| 6.4 | 1 | < 0.1% |
| 6.67 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 392 | 1 | |
| 387 | 1 | |
| 357 | 1 | |
| 349.63 | 1 | |
| 343 | 1 | |
| 340 | 2 | |
| 336.57 | 1 | |
| 330 | 1 | |
| 329.67 | 1 | |
| 328 | 2 |
required_car_parking_spaces
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 93.4 KiB |
| 0 | |
|---|---|
| 1 | 715 |
| 2 | 3 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 11939 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 11221 | |
| 1 | 715 | 6.0% |
| 2 | 3 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 11221 | |
| 1 | 715 | 6.0% |
| 2 | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 11221 | |
| 1 | 715 | 6.0% |
| 2 | 3 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 11939 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 11221 | |
| 1 | 715 | 6.0% |
| 2 | 3 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 11939 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 11221 | |
| 1 | 715 | 6.0% |
| 2 | 3 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11939 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 11221 | |
| 1 | 715 | 6.0% |
| 2 | 3 | < 0.1% |
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.569645699 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 7020 |
| Zeros (%) | 58.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 93.4 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7871496621 |
|---|---|
| Coefficient of variation (CV) | 1.381823234 |
| Kurtosis | 1.5214115 |
| Mean | 0.569645699 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.340795689 |
| Sum | 6801 |
| Variance | 0.6196045905 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 7020 | |
| 1 | 3341 | |
| 2 | 1318 | 11.0% |
| 3 | 221 | 1.9% |
| 4 | 34 | 0.3% |
| 5 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 7020 | |
| 1 | 3341 | |
| 2 | 1318 | 11.0% |
| 3 | 221 | 1.9% |
| 4 | 34 | 0.3% |
| 5 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 5 | < 0.1% |
| 4 | 34 | 0.3% |
| 3 | 221 | 1.9% |
| 2 | 1318 | 11.0% |
| 1 | 3341 | |
| 0 | 7020 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 765.2 KiB |
| Check-Out | |
|---|---|
| Canceled | |
| No-Show | 121 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.620236201 |
| Min length | 7 |
Characters and Unicode
| Total characters | 102917 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Check-Out |
|---|---|
| 2nd row | Check-Out |
| 3rd row | Check-Out |
| 4th row | Canceled |
| 5th row | Check-Out |
Common Values
| Value | Count | Frequency (%) |
| Check-Out | 7526 | |
| Canceled | 4292 | |
| No-Show | 121 | 1.0% |
Length
Pie chart
| Value | Count | Frequency (%) |
| check-out | 7526 | |
| canceled | 4292 | |
| no-show | 121 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 16110 | |
| C | 11818 | |
| c | 11818 | |
| h | 7647 | |
| - | 7647 | |
| k | 7526 | |
| O | 7526 | |
| u | 7526 | |
| t | 7526 | |
| a | 4292 | 4.2% |
| Other values (7) | 13481 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 75684 | |
| Uppercase Letter | 19586 | 19.0% |
| Dash Punctuation | 7647 | 7.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 16110 | |
| c | 11818 | |
| h | 7647 | |
| k | 7526 | |
| u | 7526 | |
| t | 7526 | |
| a | 4292 | 5.7% |
| n | 4292 | 5.7% |
| l | 4292 | 5.7% |
| d | 4292 | 5.7% |
| Other values (2) | 363 | 0.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| C | 11818 | |
| O | 7526 | |
| N | 121 | 0.6% |
| S | 121 | 0.6% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 7647 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 95270 | |
| Common | 7647 | 7.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 16110 | |
| C | 11818 | |
| c | 11818 | |
| h | 7647 | |
| k | 7526 | |
| O | 7526 | |
| u | 7526 | |
| t | 7526 | |
| a | 4292 | 4.5% |
| n | 4292 | 4.5% |
| Other values (6) | 9189 |
Common
| Value | Count | Frequency (%) |
| - | 7647 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 102917 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 16110 | |
| C | 11818 | |
| c | 11818 | |
| h | 7647 | |
| - | 7647 | |
| k | 7526 | |
| O | 7526 | |
| u | 7526 | |
| t | 7526 | |
| a | 4292 | 4.2% |
| Other values (7) | 13481 |
| Distinct | 852 |
|---|---|
| Distinct (%) | 7.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 758.0 KiB |
| 21-10-15 | 137 |
|---|---|
| 06-07-15 | 77 |
| 25-11-16 | 73 |
| 18-01-16 | 73 |
| 01-01-15 | 69 |
| Other values (847) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 95512 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 26 ? |
|---|---|
| Unique (%) | 0.2% |
Sample
| 1st row | 30-11-15 |
|---|---|
| 2nd row | 25-04-16 |
| 3rd row | 03-01-16 |
| 4th row | 27-11-16 |
| 5th row | 27-04-16 |
Common Values
| Value | Count | Frequency (%) |
| 21-10-15 | 137 | 1.1% |
| 06-07-15 | 77 | 0.6% |
| 25-11-16 | 73 | 0.6% |
| 18-01-16 | 73 | 0.6% |
| 01-01-15 | 69 | 0.6% |
| 07-12-16 | 47 | 0.4% |
| 02-07-15 | 40 | 0.3% |
| 31-01-17 | 37 | 0.3% |
| 15-03-16 | 37 | 0.3% |
| 09-02-16 | 36 | 0.3% |
| Other values (842) | 11313 |
Length
| Value | Count | Frequency (%) |
| 21-10-15 | 137 | 1.1% |
| 06-07-15 | 77 | 0.6% |
| 25-11-16 | 73 | 0.6% |
| 18-01-16 | 73 | 0.6% |
| 01-01-15 | 69 | 0.6% |
| 07-12-16 | 47 | 0.4% |
| 02-07-15 | 40 | 0.3% |
| 31-01-17 | 37 | 0.3% |
| 15-03-16 | 37 | 0.3% |
| 09-02-16 | 36 | 0.3% |
| Other values (842) | 11313 |
Most occurring characters
| Value | Count | Frequency (%) |
| - | 23878 | |
| 1 | 21879 | |
| 0 | 15069 | |
| 6 | 7888 | 8.3% |
| 2 | 6894 | 7.2% |
| 7 | 6063 | 6.3% |
| 5 | 4722 | 4.9% |
| 3 | 2648 | 2.8% |
| 8 | 2317 | 2.4% |
| 9 | 2127 | 2.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 71634 | |
| Dash Punctuation | 23878 | 25.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 21879 | |
| 0 | 15069 | |
| 6 | 7888 | 11.0% |
| 2 | 6894 | 9.6% |
| 7 | 6063 | 8.5% |
| 5 | 4722 | 6.6% |
| 3 | 2648 | 3.7% |
| 8 | 2317 | 3.2% |
| 9 | 2127 | 3.0% |
| 4 | 2027 | 2.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 23878 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 95512 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| - | 23878 | |
| 1 | 21879 | |
| 0 | 15069 | |
| 6 | 7888 | 8.3% |
| 2 | 6894 | 7.2% |
| 7 | 6063 | 6.3% |
| 5 | 4722 | 4.9% |
| 3 | 2648 | 2.8% |
| 8 | 2317 | 2.4% |
| 9 | 2127 | 2.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 95512 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| - | 23878 | |
| 1 | 21879 | |
| 0 | 15069 | |
| 6 | 7888 | 8.3% |
| 2 | 6894 | 7.2% |
| 7 | 6063 | 6.3% |
| 5 | 4722 | 4.9% |
| 3 | 2648 | 2.8% |
| 8 | 2317 | 2.4% |
| 9 | 2127 | 2.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| df_index | hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 80965 | City Hotel | 0 | 2 | 2015 | November | 48 | 27 | 1 | 2 | 2 | 0.0 | 0 | BB | FRA | Direct | Direct | 0 | 0 | 0 | D | D | 0 | No Deposit | 14.0 | NaN | 0 | Transient | 85.00 | 0 | 0 | Check-Out | 30-11-15 |
| 1 | 23416 | Resort Hotel | 0 | 27 | 2016 | April | 17 | 22 | 1 | 2 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | E | E | 0 | No Deposit | 240.0 | NaN | 0 | Transient | 85.00 | 0 | 1 | Check-Out | 25-04-16 |
| 2 | 82624 | City Hotel | 0 | 40 | 2015 | December | 53 | 31 | 0 | 3 | 2 | 0.0 | 0 | BB | FRA | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 104.0 | NaN | 0 | Transient | 118.00 | 0 | 0 | Check-Out | 03-01-16 |
| 3 | 62104 | City Hotel | 1 | 123 | 2017 | January | 1 | 2 | 1 | 1 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 9.0 | NaN | 0 | Transient | 102.60 | 0 | 1 | Canceled | 27-11-16 |
| 4 | 87859 | City Hotel | 0 | 68 | 2016 | April | 17 | 23 | 2 | 2 | 2 | 0.0 | 0 | BB | FRA | Direct | Direct | 0 | 0 | 0 | D | D | 0 | No Deposit | NaN | NaN | 0 | Transient | 102.85 | 0 | 0 | Check-Out | 27-04-16 |
| 5 | 25646 | Resort Hotel | 0 | 158 | 2016 | June | 27 | 28 | 2 | 5 | 2 | 0.0 | 0 | BB | CHE | Direct | Direct | 0 | 0 | 0 | E | F | 0 | No Deposit | NaN | NaN | 0 | Transient | 131.50 | 1 | 1 | Check-Out | 05-07-16 |
| 6 | 52161 | City Hotel | 1 | 113 | 2016 | May | 23 | 31 | 0 | 3 | 1 | 0.0 | 0 | BB | PRT | Corporate | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | NaN | 202.0 | 0 | Transient | 100.00 | 0 | 0 | Canceled | 11-04-16 |
| 7 | 57010 | City Hotel | 1 | 205 | 2016 | September | 38 | 16 | 1 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 37.0 | NaN | 0 | Transient | 120.00 | 0 | 0 | Canceled | 15-03-16 |
| 8 | 43958 | City Hotel | 1 | 88 | 2015 | September | 39 | 26 | 2 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 1.0 | NaN | 0 | Transient | 170.00 | 0 | 0 | Canceled | 09-09-15 |
| 9 | 79032 | City Hotel | 0 | 0 | 2015 | October | 43 | 20 | 0 | 1 | 1 | 0.0 | 0 | BB | ITA | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | B | 1 | No Deposit | 87.0 | NaN | 0 | Transient | 123.00 | 0 | 0 | Check-Out | 21-10-15 |
Last rows
| df_index | hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | agent | company | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11929 | 66021 | City Hotel | 1 | 106 | 2017 | April | 15 | 13 | 0 | 2 | 2 | 0.0 | 0 | SC | ESP | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9.0 | NaN | 0 | Transient | 108.00 | 0 | 0 | Canceled | 01-01-17 |
| 11930 | 62215 | City Hotel | 1 | 545 | 2017 | January | 1 | 5 | 0 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 1.0 | NaN | 0 | Transient | 62.00 | 0 | 0 | Canceled | 21-10-15 |
| 11931 | 20374 | Resort Hotel | 0 | 4 | 2016 | January | 5 | 26 | 0 | 1 | 1 | 0.0 | 0 | BB | PRT | Corporate | Corporate | 0 | 0 | 0 | A | D | 0 | No Deposit | NaN | NaN | 0 | Transient | 38.00 | 0 | 0 | Check-Out | 27-01-16 |
| 11932 | 22464 | Resort Hotel | 0 | 36 | 2016 | March | 13 | 24 | 0 | 3 | 3 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 314.0 | NaN | 0 | Transient | 81.00 | 0 | 1 | Check-Out | 27-03-16 |
| 11933 | 6487 | Resort Hotel | 1 | 221 | 2016 | June | 25 | 12 | 3 | 5 | 2 | 0.0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | G | G | 0 | No Deposit | 250.0 | NaN | 0 | Transient | 114.75 | 0 | 1 | Canceled | 09-11-15 |
| 11934 | 77023 | City Hotel | 0 | 14 | 2015 | September | 36 | 1 | 0 | 1 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | D | 0 | No Deposit | 9.0 | NaN | 0 | Contract | 105.00 | 0 | 2 | Check-Out | 02-09-15 |
| 11935 | 57541 | City Hotel | 1 | 250 | 2016 | September | 40 | 26 | 1 | 3 | 2 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 3.0 | NaN | 0 | Transient | 95.00 | 0 | 0 | Canceled | 28-06-16 |
| 11936 | 82770 | City Hotel | 1 | 68 | 2016 | February | 8 | 17 | 0 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 1 | 0 | A | A | 0 | Non Refund | 37.0 | NaN | 0 | Transient | 75.00 | 0 | 0 | Canceled | 06-01-16 |
| 11937 | 109861 | City Hotel | 0 | 177 | 2017 | April | 15 | 15 | 2 | 1 | 2 | 0.0 | 0 | HB | CN | Groups | TA/TO | 0 | 0 | 0 | A | A | 1 | No Deposit | 2.0 | NaN | 0 | Transient-Party | 105.33 | 0 | 1 | Check-Out | 18-04-17 |
| 11938 | 34515 | Resort Hotel | 0 | 241 | 2017 | March | 12 | 21 | 2 | 5 | 1 | 0.0 | 0 | BB | GBR | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 273.0 | NaN | 0 | Transient-Party | 28.80 | 0 | 0 | Check-Out | 28-03-17 |